Date Formats
When creating a new field with a field type of Date Format, you need to select the date format type from the Format drop-down.
The table below describes each format type.
Please note that in the Format column:
- A slash (/) or dash (-) represents the separator character. When the document is generated in Studio, this slash or dash will be replaced by the character you have selected using the Separator drop-down list. The separator can be a slash, comma, dash, period, or space. You can also choose to have no separator.
- YY represents the year, which can be 2 or 4 digits depending on Year Size setting; in the examples below, the Year Size is assumed to be 4. Yr and YYYY represent a 4 digit year, regardless of the Year Size setting.
- b applies only to days and months that can be represented as a single digit.Specifically, b represents a blank space that will appear for a single-digit day (the 1st to the 9th of any month) or for a single-digit month (January through to September, which are months 1 to 9). b does not apply to two-digit days (the 10th to the 31st) or to two-digit months (October to December).
| Format | Description |
Example for a date of February 7, 2012 |
|---|---|---|
| bD/bM/YY |
the numeric day and month with spaces instead of leading zeros, and the year, with the designated separator |
_7/ 2/2012 (where _ represents a space) |
| bM/bD/YY |
the numeric month and day with spaces instead of leading zeros, and the year, with the designated separator |
_ 2/ 7/2012 (where _ represents a space) |
| D Month, Yr | the day, the full name of month, and the 4-digit year | 7 February, 2012 |
| D/M/YY | the numeric day and month with no leading zeros, and the year, with the designated separator | 7/2/2012 |
| DD/MM/YY | the numeric day and month with leading zeros, and the year, with the designated separator | 07/02/2012 |
| DDMMYY | the numeric day and month with leading zeros, and the year, with no separators | 07022012 |
| DDMonYY | the numeric day with leading zeros, the abbreviated month name, and the year, with no separators | 07Feb2012 |
| DD-Mon-YY | the numeric day with leading zeros, the abbreviated month name, and the year, with the designated separator | 07-Feb-2012 |
| M/D/YY | the numeric month and day with no leading zeros, and the year, with the designated separator | 2/7/2012 |
| MM/DD/YY | the numeric month and day with leading zeros, and the year, with the designated separator | 02/07/2012 |
| MMDDYY | the numeric month and day with leading zeros, and the year, with no separators | 02072012 |
| MonDDYY | the abbreviated month name, the numeric day with leading zeros, and the year, with no separators | Feb072012 |
| Mon-DD-YY | the abbreviated month name, the numeric day with leading zeros, and the year, with the designated separator | Feb-07-2012 |
| Month D, Yr | the full month name, the numeric day with no leading zeros, and the year | February 7, 2012 |
| Yr, Month D | the 4-digit year, the full month name, and the numeric day with no leading zeros | 2012, February 7 |
| YY/bM/bD | the year, and the numeric month and day with spaces instead of leading zeros, with the designated separator | 2012/ 2/ 7 |
| YY/day | the year and the numeric day of the year counting from January 1, with the designated separator | 2012/48 |
| YY/M/D | the year, and the numeric month and day with no leading zeros, with the designated separator | 2012/2/17 |
| YY/MM/DD | the year, and the numeric month and day with leading zeros, with the designated separator | 2012/02/07 |
| YYMMDD | the year, and the numeric month and day with leading zeros, with no separators | 20120207 |
| YYMonDD | the year, the abbreviated month,and the numeric day with leading zeros, with no separators | 2012Feb07 |
| YY-Mon-DD | the year, the abbreviated month name, the numeric day with leading zeros, with the designated separator | 2012-Feb-07 |
See Also